<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="file:///C|/Program Files (x86)/Apache Software Foundation/Apache2.2/htdocs/Templates/TemplateE.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>CircleU</title>
<?php
 	session_start(); 
	if( !$_SESSION["login"])header('Location: error_page.php');
	include("db_util.php");
	putenv("ORACLE_HOME=/usr/local/libexec/oracle/app/oracle/product/11.2.0/client_1");
	$connection=DbConnect();
	if(!$connection)
		echo "DisConnected!<br>";
	if(isset($_GET["GSID"]))$SID=$_GET["GSID"]; else $SID=$_SESSION["StuID"];
	$query='SELECT * FROM Student where sid=' . $SID; 
	$statement = oci_parse($connection, $query);
	$query='SELECT name, GID FROM STUGROUP SG, GROUPS G WHERE sg.STUDENTID=' . $SID . 'and G.GID=SG.GroupID';
	$statement1 = oci_parse($connection, $query);
	$query='SELECT cname, CID FROM StuCourse SC, Course C WHERE sc.STUDENTID=' . $SID . 'and C.CID=SC.CourseID';
	$statement2 = oci_parse($connection, $query);
	oci_execute($statement);
	oci_execute($statement1);
	oci_execute($statement2);
	ocifetch ( $statement ) ;	
?>
<!-- InstanceEndEditable -->
<style type="text/css">
<!--

a:link   {
text-decoration:   none;
}
a:visited   {
text-decoration:   none;
}
a:hover   {
text-decoration:   underline;
} 
.try {
	background-color: #FFFFFF;
	position: relative;
	z-index: auto;
	visibility: visible;
	clip: rect(auto,auto,auto,auto);
	width: auto;
	height: 76px;
}
.copyright {
	position: absolute;
	left: 150px;
	top: 600px;
	font-size: large;
	height: 22px;
}
.LayerImg {
	left: auto;
}
.CircleU {
	font-family: "Comic Sans MS";
	font-size: xx-large;
	font-weight: bold;
	position: relative;
	left: 20px;
	top: auto;
	height: auto;
	width: auto;
	visibility: visible;
	background-position: left;
	color: #3333FF;
}
#Title1 {
	position:absolute;
	width:1096px;
	height:60px;
	z-index:2;
	left: 9px;
	top: 6px;
}



}

#Dwt01 {
	position:absolute;
	width:1092px;
	height:500px;
	right: 9px;
	top: 80px;
}
#LeftLayer {
	position:absolute;
	width:200px;
	height:500px;
	z-index:3;
	left: 11px;
	top: 77px;
	background-color: #FF6600;
}
#EditR1 {
	position:absolute;
	width:878px;
	height:500px;
	z-index:4;
	left: 221px;
	top: 77px;
}
.STYLE3 {color: #0000CC}
#Layer1 {
	position:absolute;
	width:181px;
	height:217px;
	z-index:1;
	left: 2px;
	top: 2px;
}
-->
</style>
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
#Layer2 {
	position:absolute;
	width:873px;
	height:398px;
	z-index:5;
	left: 1px;
	top: 91px;
}
#form3 textarea {
	height: 80px;
	width: 584px;
}
#Layer3 {
	position:absolute;
	width:870px;
	height:80px;
	z-index:5;
	top: 1px;
	left: -57px;
}
#LayerCover {
	position:absolute;
	width:566px;
	height:78px;
	z-index:5;
	left: 150px;
	top: 119px;
}
#Layer4 {
	position:absolute;
	width:864px;
	height:102px;
	z-index:5;
	left: -58px;
	top: 86px;
}
#Layer5 {
	position:absolute;
	width:720px;
	height:33px;
	z-index:5;
	left: -18px;
	top: 524px;
}
.STYLE4 {
	font-family: "Comic Sans MS";
	color: #0000CC;
}
-->
</style>
<!-- InstanceEndEditable -->
</head>

<body>
<center>
  <div id="Title1">
    <table width="1092" height="59" bgcolor="#FF6600">
      <tr>
        <td rowspan="2" class="CircleU"><div align="left"><?php echo "<a href=\"index.php\">"; ?> <span class="STYLE3">CircleU</a></span></div></td>
        <td width="128"><?php echo "<a href=\"index.php\">"; ?> </a></td>
        <td width="111"><div align="right"><?php echo "<a href=\"SignOut.php\">"; ?></a></div></td>
        <td width="120"><div align="center"><?php echo "<a href=\"ContactUs.php\">"; ?>Contact Us</a></div></td>
      </tr>
      <tr>
        <td><form id="form2" name="form2" method="post" <?php echo "action=\"AdvancedSearch.php\""; ?>>
          <label></label>
        </form>
        </td>
        <td colspan="2"><form id="form1" name="form1" method="post" <?php echo "action=\"SearchResult.php\""; ?>>
          <label></label>
          <label></label>
        </form>        </td>
      </tr>
    </table>
  </div>
  <div id="LeftLayer"></div>
  <div id="EditR1"><!-- InstanceBeginEditable name="EditRegion3" -->
    <div class="copyright" id="Layer5">Copyright @ 2011 CircleU built in University of Florida. All right reserved</div>
    <div id="Layer4">
      <table width="500" border="2">
        <tr>
          <td width="139" height="28"><div align="center">CEO:</div></td>
          <td width="89">Mingmin Zhu </td>
          <td width="171">zhumingming@gmail.com</td>
        </tr>
        <tr>
          <td height="30"><div align="center">CTO:</div></td>
          <td>Yan Qiao </td>
          <td>yanqiao.sjtu@gmail.com</td>
        </tr>
        <tr>
          <td height="29"><div align="center">VCTO:</div></td>
          <td>Wen Luo </td>
          <td>wluo@gmail.com</td>
        </tr>
        <tr>
          <td height="27"><div align="center">Worker:</div></td>
          <td>Chang Liu </td>
          <td>cliu0526@gmail.com</td>
        </tr>
        <tr>
          <td height="27"><div align="center">Mail Adress : </div></td>
          <td height="27" colspan="2">1650  sw MainStreet Gainesville FL 32607 </td>
        </tr>
        <tr>
          <td height="27"><div align="center">Phone: </div></td>
          <td height="27" colspan="2">123-456-789</td>
        </tr>
        <tr>
          <td height="27" colspan="3"><span class="STYLE4">We are glad to get any comments from you. </span></td>
        </tr>
      </table>
    </div>
    <div class="CircleU" id="Layer3">Contact Us </div>
    <!-- InstanceEndEditable --></div>
</center>
</body>
<!-- InstanceEnd --></html>
